Tabela TherapyGroup

Definicja tabeli TherapyGroup

Name

TherapyGroup

Code

TherapyGroup

Comment

Slownik grup terapeutycznych w module leków. Dodatkowe powiazanie do
wykorzystania funkcjonalnosci uprawnien w systemie [SysFctID].


Lista kolumn tabeli TherapyGroup

Name

Code

TherapyGroupID

TherapyGroupID

SysFctID

SysFctID

Active

Active

Code

Code

Description

Description

FullName

FullName

ShortName

ShortName

StartDT

StartDT

StopDT

StopDT


Kolumna TherapyGroupID tabeli TherapyGroup

Definicja kolumny TherapyGroupID tabeli TherapyGroup

Name

TherapyGroupID

Code

TherapyGroupID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna SysFctID tabeli TherapyGroup

Definicja kolumny SysFctID tabeli TherapyGroup

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli TherapyGroup

Definicja kolumny Active tabeli TherapyGroup

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Code tabeli TherapyGroup

Definicja kolumny Code tabeli TherapyGroup

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna Description tabeli TherapyGroup

Definicja kolumny Description tabeli TherapyGroup

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna FullName tabeli TherapyGroup

Definicja kolumny FullName tabeli TherapyGroup

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna ShortName tabeli TherapyGroup

Definicja kolumny ShortName tabeli TherapyGroup

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna StartDT tabeli TherapyGroup

Definicja kolumny StartDT tabeli TherapyGroup

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli TherapyGroup

Definicja kolumny StopDT tabeli TherapyGroup

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli TherapyGroup

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TherapyGroup

Definicja klucza Identifier_1 tabeli TherapyGroup

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment